# import matplotlib.pyplot as plt
# import pandas as pd
# df=pd.read_excel('餐饮综合数据.xlsx',sheet_name='订单详情表',index_col=0)
# plt.rcParams['font.sans-serif']='SimHei'
# x=df['价格']
# plt.xlabel('菜单价格/元')
# plt.ylabel('菜单数量')
# plt.title('不同价格')
# plt.hist(x,bins=12,color=(0.894,0,0.489),edgecolor='k')
# plt.show()





import matplotlib.pyplot as plt
import pandas as pd
df=pd.read_excel('cjd.xlsx',index_col=0)
plt.rcParams['font.sans-serif']='SimHei'
x=df['数学']
plt.xlabel('成绩/人')
plt.ylabel('学期')
plt.title('不同成绩')
plt.hist(x,bins=12,color=(0.894,0.89,0.489),edgecolor='k')
plt.show()